<?php

class InventoryactController extends Controller {

    /**
     * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
     * using two-column layout. See 'protected/views/layouts/column2.php'.
     */
    public $layout = '//layouts/column2';

    /**
     * @return array action filters
     */
    public function filters() {
        return array(
            'accessControl', // perform access control for CRUD operations
        );
    }

    /**
     * Specifies the access control rules.
     * This method is used by the 'accessControl' filter.
     * @return array access control rules
     */
    public function accessRules() {
        return array(
            array('allow', // allow all users to perform 'index' and 'view' actions
               
                'users'=>array('@'),
            ),
        
            array('deny', // deny all users
                'users' => array('*'),
            ),
        );
    }

    /**
     * Displays a particular model.
     * @param integer $id the ID of the model to be displayed
     */
    public function actionView($id) {
        $this->render('view', array(
            'model' => $this->loadModel($id),
        ));
    }

    /**
     * Creates a new model.
     * If creation is successful, the browser will be redirected to the 'view' page.
     */
    public function actionCreate($partno) {
        $model = new Inventoryact;
        $model->partno=$partno;
        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);

        if (isset($_POST['Inventoryact'])) {
            $model->attributes = $_POST['Inventoryact'];
            if ($model->save())
                $this->redirect(array('view', 'id' => $model->id));
        }

        $this->render('create', array(
            'model' => $model,
        ));
    }

    /**
     * Updates a particular model.
     * If update is successful, the browser will be redirected to the 'view' page.
     * @param integer $id the ID of the model to be updated
     */
    public function actionUpdate($id) {
        $model = $this->loadModel($id);

        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);

        if (isset($_POST['Inventoryact'])) {
            $model->attributes = $_POST['Inventoryact'];
            if ($model->save())
                $this->redirect(array('view', 'id' => $model->id));
        }

        $this->render('update', array(
            'model' => $model,
        ));
    }

    /**
     * Deletes a particular model.
     * If deletion is successful, the browser will be redirected to the 'admin' page.
     * @param integer $id the ID of the model to be deleted
     */
    public function actionDelete($id) {

        // we only allow deletion via POST request
        $model=$this->loadModel($id);
        $partno=$model->partno;
        $model->delete();

        // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
        if (!isset($_GET['ajax']))
            $this->redirect(array('index','partno'=>$partno));
    }

    /**
     * Lists all models.
     */
    public function actionIndex($partno) {
        $inventory = Inventory::model()->findByPk($partno);
        $this->render('index', array(
            'inventory' => $inventory
        ));
    }

    /**
     * Manages all models.
     */
    public function actionAdmin() {
        $model = new Inventoryact('search');
        $model->unsetAttributes();  // clear any default values
        if (isset($_GET['Inventoryact']))
            $model->attributes = $_GET['Inventoryact'];

        $this->render('admin', array(
            'model' => $model,
        ));
    }

    /**
     * Returns the data model based on the primary key given in the GET variable.
     * If the data model is not found, an HTTP exception will be raised.
     * @param integer the ID of the model to be loaded
     */
    public function loadModel($id) {
        $model = Inventoryact::model()->findByPk($id);
        if ($model === null)
            throw new CHttpException(404, 'The requested page does not exist.');
        return $model;
    }

    /**
     * Performs the AJAX validation.
     * @param CModel the model to be validated
     */
    protected function performAjaxValidation($model) {
        if (isset($_POST['ajax']) && $_POST['ajax'] === 'inventoryact-form') {
            echo CActiveForm::validate($model);
            Yii::app()->end();
        }
    }
    public function actionQtyCount($partno){
        $sum=Yii::app()->db->createCommand('SELECT SUM( qty ) - SUM( qtyout ) 
FROM  `tbl_inventoryact` 
WHERE TYPE =  "I"
AND partno=:partno')->bindValue('partno', $partno)->queryScalar();
        if($sum!=false){
            echo $sum;
        }else{
            echo 0;
        }
        Yii::app()->end();
    
    }
    public function actionList($partno=NULL,$page=NULL,$sort=NULL){
        if($page>0) $page--;
        $order=CJSON::decode($sort);
        
        $crit=new CDbCriteria();
        $crit->select=array('partno,partdesc,warehouse', ' SUM( qty ) - SUM( qtyout )  as total');
        $crit->condition='TYPE =  "I" and partno=:partno';
        $crit->params=array(
            'partno'=>$partno
        );
        $crit->order=isset($order)?$order[0]['property'].' '.$order[0]['direction']:NULL;
        
        $crit->group='warehouse';
        $crit->having='SUM( qty ) - SUM( qtyout ) > 0';
        
        $data=new CActiveDataProvider('Inventoryact',array(
            'criteria'=>$crit,
            'pagination'=>array(
                'pageSize'=>20,
                'currentPage'=>$page
            )
        ));

        if($data!=NULL && count($data->getData())>0){
            $rs=array();
            $rs['totalCount']=$data->getTotalItemCount();
            
            foreach($data->getData() as $i=>$item){
                
                /* var Warehouse $item*/
                
               // $rs['data'][$i]['partno']=$item->partno;
               // $rs['data'][$i]['partdesc']=$item->partdesc;
                $rs['data'][$i]['total']=$item->total;
                $rs['data'][$i]['warehouse']=$item->warehouse;
                
                $rs['data'][$i]['warehouse']=$item->warehouse .' - '.Warehouse::model()->getText($item->warehouse);
            }
            echo json_encode($rs);
        }
        Yii::app()->end();
    }

}
